Release 10.1A: OpenEdge Data Management:
SQL Reference

AUDIT INSERT

Writes application audit events to an audit-enabled database.

For more information about auditing, see OpenEdge Getting Started: Core Business Services . For more information about enabling a database for auditing, see OpenEdge Data Management: Database Administration .

Syntax

AUDIT INSERT ( event_id,              [ event_context | NULL ]              [ event_detail | NULL ]               );

event_id

Positive integer value corresponding to an audit event record. The event_id must be a value greater than 32000.

event_context

Free-form character value that qualifies the event_id. May include non-ASCII characters.

event_detail

Free-form character value that supplies detailed information about the audit event. May include non-ASCII characters.

Notes

Before inserting the specified application audit event into the database, the OpenEdge SQL engine determines the following:
The connected user has been granted the audit insert privilege.
The event id is valid and active.

If both of these conditions are true, the engine writes the application audit event to the database. If one or both are not true, the engine does not write the event.

AUDIT INSERT always returns a success status. This prevents users from determining whether or not they have privileges to log application audit events.